Loading the Data File and Creating the Application

Final Dashboard should look like this:



1- Downloading the data File:

Download the excel file to location of your choice and Extract the zip file.

2- Create the Application:

a-      Open Qlik Sense app and click "Create New App"

b-      Name The application we name it "Global Superstore dashboard''  

Click "Create" and then click "Open App"


3-Loading the file to Qlik database:

a-      Click to open the application

b-      Click on Add Data files and other sources

c-       From the left side select from my computer

d-      Select the path file or look for the file by selecting C/User/computer's name and then look for the file location


 


       4-Create associations, or relationships, between the tables: 

a. Drag the dimension tables to the Fact table to create associations

b. Make sure the associations are matched with the proper Serial Key. Below are the associations. 

Select only the three tables Order, People, and Returns


Note: Master Calendar will be loaded separately  

Please go to the Master Calendar steps, to load the Master Calendar extension 

Your final  association keys should look like this:



        This is what what you will create at the end of the project :